UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'o8p2oB+1BM1rkcXoSABoJ7pUGdqv3J2tWlM6gVRGUUQ='
WHERE
key_id = 'cdaa9a5d4ddb056d28260e6b461a62fc6e0940632e2ce1525f82c3b5acad2d59'
AND (
token = 'o8p2oB+1BM1rkcXoSABoJ7pUGdqv3J2tWlM6gVRGUUQ='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)