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