UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'ae1DZA4ZsTId1ZpP04BF+dOcL5VY624/kEaGmgZxW20='
WHERE
key_id = '42f4fd625f59407e07a398abd1adfe35e22c409342a7876e77e7d30cd941c979'
AND (
token = 'ae1DZA4ZsTId1ZpP04BF+dOcL5VY624/kEaGmgZxW20='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)