UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'oTpcpE2iKqZQcIdkjK36jkyLHmTK3oLVsp/9o5OwAHM='
WHERE
key_id = '4c61786f1d3bdb861d6e6c1504a77443367e5d8b30bd06e44e3c6201dd433d2b'
AND (
token = 'oTpcpE2iKqZQcIdkjK36jkyLHmTK3oLVsp/9o5OwAHM='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)