UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'PnlZzlZ0nLbbRfZXlSdjaRLGlFq8Ho5eNgE1EgsJF50='
WHERE
key_id = '20b0eff1eceaf88e910048c61ea15035aa3069ced5dd9f272fde4e6b6f9c10d8'
AND (
token = 'PnlZzlZ0nLbbRfZXlSdjaRLGlFq8Ho5eNgE1EgsJF50='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)