UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '8h67sJcH2+v4293z6sV8e1sMqiRDR91imtzmiZwXbyk='
WHERE
key_id = '8163c69740ee6aae6f8080ecd481f1470f03c904b8d7e15c4831e23fc64d59a3'
AND (
token = '8h67sJcH2+v4293z6sV8e1sMqiRDR91imtzmiZwXbyk='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)