UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'VNvCZu5VT7krh3n1jdCI+Jr/NRWdedwB479qfEQVQYQ='
WHERE
key_id = '4b6ed8156cf47bb007fda4ff964b4df34dee95a74f348190696dd63b416d52a3'
AND (
token = 'VNvCZu5VT7krh3n1jdCI+Jr/NRWdedwB479qfEQVQYQ='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)