UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'zYdH3iFTi68p0It8/+k9+naL/dNWgxpXDT2oOsE9+I8='
WHERE
key_id = '41313b803c1919dff3fcc18f14731ef5fb0444b7b31cdfa63250699f5fb960bb'
AND (
token = 'zYdH3iFTi68p0It8/+k9+naL/dNWgxpXDT2oOsE9+I8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)