UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'a47b5J5p6V7hg2iB7DoqmUMoIdK9YOpv6sKCHLN9ORY='
WHERE
key_id = 'c225f4bd5001099f02bab3322f355ba37aad91217b8fe5a7408a8f184f705263'
AND (
token = 'a47b5J5p6V7hg2iB7DoqmUMoIdK9YOpv6sKCHLN9ORY='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)