UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'iVxCfevGXSA6tvl0FBBTvoKeWfbFhIfOe3wl3eb54CU='
WHERE
key_id = '46463c318dfcd30fa25dd931eff800a16460c6f2839b0fdb3f6990b35f3724a6'
AND (
token = 'iVxCfevGXSA6tvl0FBBTvoKeWfbFhIfOe3wl3eb54CU='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)