UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'tOAjiSl3FClSi/6nUO8IShusgW0rZXNHf/bVFpp8zWs='
WHERE
key_id = 'cf59047ca8baa808cfa5c8cc9032e36fd61c8891cd34ceefe623fa298fedbbb1'
AND (
token = 'tOAjiSl3FClSi/6nUO8IShusgW0rZXNHf/bVFpp8zWs='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)