UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'PXv9q6EoywKEK1vrOuEoFF0DZzZgXgfPacvundxcsVI='
WHERE
key_id = '4f3ffc7a1bdb3f4cd821147e087591e2f84f65054ee6e795caca97ee30054dee'
AND (
token = 'PXv9q6EoywKEK1vrOuEoFF0DZzZgXgfPacvundxcsVI='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)