UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '9mmW+yH7ElnsO1YwWtjhg8e5IIWYQGI/sjFTpcCNikg='
WHERE
key_id = 'a7c789709c3b6d4011de7e0b87ba496c9da35c902dd5b9fad277c755b6b84f5f'
AND (
token = '9mmW+yH7ElnsO1YwWtjhg8e5IIWYQGI/sjFTpcCNikg='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)