UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'CX6VfJSUfVWZkrAe1OrwqCbQ6+4FzfRMw9gscorG0u4='
WHERE
key_id = 'a4ac6b1365692c09f27525ae859b224910e7e109b7b99ec7524d06a6002cf833'
AND (
token = 'CX6VfJSUfVWZkrAe1OrwqCbQ6+4FzfRMw9gscorG0u4='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)