UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '6XrO3zqBuA6GBYMh8SFM67m+JcryfckaNR7TpZt77uw='
WHERE
key_id = 'a4c376eeac13f59a64b911c955318dd910c8134c923d4dafc7d44e949b485c1c'
AND (
token = '6XrO3zqBuA6GBYMh8SFM67m+JcryfckaNR7TpZt77uw='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)