UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '/xREKAxWyOlDNK7BkwY/EAFsmqXClxuASfMHmSk0a8w='
WHERE
key_id = 'c6153b79c841c8740bb26a63b8a494ce92d2f6167c2b1011441bcb63533fc9f7'
AND (
token = '/xREKAxWyOlDNK7BkwY/EAFsmqXClxuASfMHmSk0a8w='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)