UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'gCAXyInmgK2z5vB6Ni3r6t/cqKIztAlMnO9umD08nYI='
WHERE
key_id = 'c987c6f12f2b8151f161fd93000c62c68bcec29012c2bdb580a72639dbdaee7d'
AND (
token = 'gCAXyInmgK2z5vB6Ni3r6t/cqKIztAlMnO9umD08nYI='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)