UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '6jDl0OdxS6Sv8ZgIyqcMCoWyNyR/f//KTlZsraFgqVk='
WHERE
key_id = 'ef2297b8cb959b13b05521860c3eb629893e498fec8ebeefa4c83130085386f4'
AND (
token = '6jDl0OdxS6Sv8ZgIyqcMCoWyNyR/f//KTlZsraFgqVk='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)