UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'XreqJhxAmvohMCBss4yXwAQkG3BBhUrvlG3ATLfANjc='
WHERE
key_id = '078c6b847732fd9d4276831b95a4ea3237370a4b2d48585b076c20d2ac01331b'
AND (
token = 'XreqJhxAmvohMCBss4yXwAQkG3BBhUrvlG3ATLfANjc='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)