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