UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'XT837fp3aGWM9utEp3phLHMpj3X+H6x91kIWURSvUdI='
WHERE
key_id = 'bc88bd2b99aada9ea197a2e213bf21e1d695e8165c0f23dbb88f84562132302f'
AND (
token = 'XT837fp3aGWM9utEp3phLHMpj3X+H6x91kIWURSvUdI='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)