UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '6R3JNamqOhXRB+wrrEXbmjAEAMgZijmO7Wo4PEnF0nI='
WHERE
key_id = '9c2ce8fed586146617b68f4467f9d89439933df5a691992d619f78656fce2721'
AND (
token = '6R3JNamqOhXRB+wrrEXbmjAEAMgZijmO7Wo4PEnF0nI='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)