UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '925xwbOgeHVhX448OHEA39ge8+UxdsYYWHc7uEuwBfM='
WHERE
key_id = 'e0f3abd59e116d04e3a2be6f1e5d1b3e163c1baea5d4626a06646dd9508df783'
AND (
token = '925xwbOgeHVhX448OHEA39ge8+UxdsYYWHc7uEuwBfM='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)