UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '1Tp9D2Pbbvtu02AoW+6jTLhLuiEKooxE3BNUHFQY8lQ='
WHERE
key_id = '6dab7be4c2617a317b76fc7b13c267b4739b50c861fe49328eb4d081f6d39584'
AND (
token = '1Tp9D2Pbbvtu02AoW+6jTLhLuiEKooxE3BNUHFQY8lQ='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)