UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'p1yinzyb9BhfrL/X4s43R3Y0N4C+oYcf6ih01ew+yZ0='
WHERE
key_id = '7a521bbef8cdcb88fe12340a07a589057a674dbc5d77538a88e32ac45dfe7c86'
AND (
token = 'p1yinzyb9BhfrL/X4s43R3Y0N4C+oYcf6ih01ew+yZ0='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)