UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'tgWrRUXOwryhL3ryAsAqC/mO8c+f3pRHyUjHvNERZrQ='
WHERE
key_id = '1805276ed0aa5a0dc500cb9f4436ca6b1b93e18f577257c35c39f094fb09ce70'
AND (
token = 'tgWrRUXOwryhL3ryAsAqC/mO8c+f3pRHyUjHvNERZrQ='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)