UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'yZD1w3Ah2bUjpoIHR7ML/lQQ7ghLn8gsXwueMAQtRpk='
WHERE
key_id = 'cae9871d3796f9818a1f0aff1a317f03675efd1b2c0e1bc4c0eea8ce2133b78c'
AND (
token = 'yZD1w3Ah2bUjpoIHR7ML/lQQ7ghLn8gsXwueMAQtRpk='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)