UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'put7wy95zW7B8gLeORJsmPrxpvaQIegSg5xmLD12XpU='
WHERE
key_id = '8077defc1a2a144987d7a743ccb3198277a95e396aa7744f567254f278a531ba'
AND (
token = 'put7wy95zW7B8gLeORJsmPrxpvaQIegSg5xmLD12XpU='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)